Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnLineItem(TR_LTM_SLS_RTN) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
ManufacturerFamilyCode (FK) | The UPC designated three digit coupon family code for the manufacturer item. | FC_FMY_MF | ProductCodeFamily | char(3) | ManufacturerCouponFamily(CO_FMY_MF_CPN) |
CouponValidationLineItem (FK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM_VLD | LineNumber | smallint | SaleReturnLineItem(TR_LTM_SLS_RTN) |
ScanCode | The barcode on a store or manufacturer coupon. The coupon scan code comprises two parts: the first is a fixed 12 character code that contains the manufacturer identification, family code, and coupon value, the second is based on Code 128 and comprises up to 20 characters. This supplementary code comprises the manufacturer's number system character, the offer code, and end of offer code. The supplementary was introduced as a guideline in 1997. | UC_CPN_SC | PostalCode | varchar(15) | |
ExpirationDate | The date a coupon may no longer be used as part of the settlement of a sale transaction. It is normally found in the UCC/EAN-128 coupon extended code. In this code, the expiration code is only four digits and contains only month and year. The day is always the last day of the month. | DC_CPN_EP | ProductCodeExpiry | varchar(20) | |
PromotionCode | Identifies a promotion associated with the coupon. Promotion codes are used by manufacturers and suppliers to analyze the impact their promotion is having on sales across a geographic area and over a specified promotional period of time. | LU_CPN_PRM | Code6 | char(6) | |
KeyEnteredFlag | A flag to denote whether the coupon is key entered or scanned, i.e. 0=no (scanned), 1=yes (key entered) | FL_ENR_CPN_KY | Flag | integer | |
ManufacturerID (FK) | A unique system assigned identifier for the Manufacturer. | ID_MF | Identity | integer | ManufacturerCouponFamily(CO_FMY_MF_CPN) |
CouponQuantity | The number of Coupons being tendered. | QY_CPN | Quantity | DECIMAL(9,3) | |
CouponTypeCode | A mnemonic code denoting what kind of Coupon is being tendered. e.g. RetailerIssued, ManufacturerIssued | TY_CPN | Code4 | char(4) | |
PrimaryLabel | A portion of the ScanCode as defined by UCC for Manufacturer issued coupons. | DE_LBL_PRMRY | Name | varchar(40) | |
SecondaryLabel | A portion of the ScanCode as defined by UCC for Manufacturer issued coupons. | DE_LBL_SCNDRY | Name | varchar(40) | |
UnusedCouponTenderFlag | Boolean indicator that if true means a coupon tender LINE ITEM was submitted that could not be applied and is being returned to a customer (applies to electronic or paper coupons issued by a supplier or vendor) | FL_UNUSD_CPN_TND | Flag | integer | |
UnusedCouponTenderReasonDescription | Reason explanation for return of a coupon. This short narrative is used to document the rationale for returning a retailer coupon to a customer. Sample reasons include: Coupon Tender out of date Out of stock-no rainchecks | DE_UNUSD_CPN_TND_RSN | DescriptionShort | varchar(255) | |